NOTE:

Assignment Type: 

• This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager.
• For shortlisted candidates who are invited for Interviews, Suppliers are required to upload the candidate’s Reference List of 3 Referees on/before the scheduled Interview date.

Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value and any extension options included in the original SOW.

Responsibilities:

• Assist with the design and configuration of the cloud infrastructure to optimally support IDMC.
• Mentor and support our ETL developers in their transition to IDMC.
• Help with the ETL code conversion from legacy Informatica PowerCenter to IDMC;
• Help with ETL processes optimization and propose and implement technical solutions whenever Powercenter code is not supported in IDMC;
• Be the main support point for any issues faced by the team which requires advanced IDMC knowledge.
• Provide knowledge transfer to other team members as needed.

Experience and Skill Set Requirements:

Informatica (10+ years) and AWS (5+ years) experience	·     Design, build and tune ETL/ELT solutions on-premises (Informatica Powercenter) and on-cloud (Informatica IDMC).	50 points
	·     Informatica transformations, mappings and workflows.
	·     Migrate ETL workloads form on-premises to public cloud (AWS).
	·     Scripting languages (Python, Linux shell).
	·     ETL processes automation and orchestration
	·     AWS services (S3, Athena, Lambda, Glue, AppFlow, Step Functions, CloudWatch etc).
Database/Data warehouse (10+ years)	·      Relational database design and optimization experience.	30 points
	·     Security controls to safeguard sensitive data (PI and PHI).
	·     Query tunning.
	·     Dimensional data modelling for data warehousing.
	·     Advanced SQL and PLSQL (or equivalent).
General Skills	·     Leadership skills with ability to identify areas for improvement and recommend solutions.	15 points
	·     Exceptional analytical, problem solving and decision-making skills.
	·     Strong interpersonal, verbal and written communication, and presentation skills.
	·     Proven troubleshooting and critical thinking experience.
	·     A motivated, flexible, detail-oriented and creative team player with perseverance, excellent organization and multi-tasking abilities, and a proven track record for meeting strict deadlines.
Public Sector/Healthcare Experience	·     Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices.	5 points
	·     Knowledge of industry standards such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies.
	·     Knowledge and understanding of Ministry policy and IT project approval processes and requirements.
	·     Experience with large complex IT Health-related projects.

Must haves:

• Informatica Hands-On Working Experience (10+ years)
• Design, build and tune ETL/ELT solutions on-premises (Informatica Powercenter)

Nice to Have:

• AWS experience
• Experience -Using Informatica on-cloud (IDMC)